Can't Save Coordinates in Spreadsheet....

[Steve Reilly]

This should probably be posted elsewhere but I'm not sure where. I need some help with trying to make an Excel spreadsheet for my targets. I’m listing the targets names, PA, bin rates, and coordinates so I can keep track of flats needed and also have a record should I later decide to go back and want to add more data. Using Excel I can’t seem to get the right cell format to keep the coordinates (RA/DEC) as copied or typed. For the RA coordinates I choose hh:mm:ss.ss but it doesn’t save as typed in. 23:20:20.46 becomes 23:20:20.20 instead. DEC seems OK with Time as 00:00:00 and keeps the vales but won’t allow a decimal value on seconds but that shouldn’t be needed. Any suggestions before I pull what little hair I have left out?

Thanks,

Steve

[Steve Reilly]

Turns out it doesn't really matter as I can save them as General text as I probably won't sort by coordinates although that may come in handy at some point.