You could try the custom format of:

##"."###"."###
or
00"."000"."000

if you want to force a zero-fill. You can now input your data as a number,
and it should display correctly.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"mgs" wrote:

I utilize a program that needs Lat and Long values to be as such ##.###.###
for data syncing purposes. I can not format the cells to maintain this
structure without turning them into 'text' format. I have thousands of data
entries and need to steamline this process rather than doing them one by one.
Is this possible?