Microsoft Office Forums - View Single Post - [Solved] Format 1,234.56 instead 1.234,56

Thread: [Solved] Format 1,234.56 instead 1.234,56

View Single Post

Old

12-14-2015, 10:05 PM

sdrawkcab

sdrawkcab is offline

sdrawkcab uses Windows 7 32bit

Windows 7 32bit sdrawkcab uses Office 2003

sdrawkcab uses Office 2003

Office 2003

Novice

Join Date: Dec 2015

Posts: 4

sdrawkcab is on a distinguished road

Default

A1 is misformatted number as per example.

B1 =VALUE(SUBSTITUTE(SUBSTITUTE(A1,".",","),",",".",2 ))

Format B1 as number and select 1000's seperator

Reply With Quote