Linked Cell Format Issue

diegoartorres

Hello everyone,

I have tried looking for this topic, however, I can't seem to find anything.

I have a source sheet with dollar amounts and the cells include a number such as $100,000.00.

When I link the cell to a new sheet, the number shows up as 100000

Any idea how to fix this?

Thank you.

Sincerely,

Diego

IanN

Hello Diego,

i would ensure that your destination column (where the 100000 is) is formatted as a currency column.  To do this click the column header to select the whole column, and then click on the currency icon in to toolbar. That should format all existing rows as $ amounts. Rows added after this should inherit the formatting as long as there are at least 2 rows above that match. 

Hope that helps. If not, our Support Team would be happy to help investigate further with you. 

Ian